package com.htjc.integral.conversion.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;

/**
 * 
 * @author bigHead
 * @time 2015/10/19
 */
@Mapper
public interface EcCorporationBoundExtMapper {
	/**
	 * 插入绑定数据
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	int insertCorporationBound(Map<String,Object> mapParam);
	/**
	 * 根据用户编号更新解绑时间
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	int updateUbByCode(Map<String,Object> mapParam);
	/**
	 * 根据用户编号更新积分
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	int updateValueByCode(Map<String,Object> mapParam);
	
	/**
	 * 单条更新
	 * @param mapParam
	 * @return
	 */
	int updateValueByCodeOneByOne(Map<String,Object> mapParam);
	/**
	 * 根据partnerId查询绑定表
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	List<Map<String,String>> selectCorporationBound(Map<String,String> map);
	/**
	 * 根据partnerId查询绑定表
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	List<Map<String,String>> selectCorporationBoundByP(Map<String,String> map);
	
	
	List<Map<String,String>> selectBoundStatus(Map<String,String> map);
	
	/**
	 * 
	 * @param corporationId 合作平台编号
	 * @return 
	 */
	List<Map<String,String>> selectCorporationById(Map<String,String> map);
	List<Map<String,String>> selectCorporation();
	/**
	 * 验证手机号
	 * @param map
	 * @return
	 */
	List<Map<String,String>> checkMobile(Map<String,String> map);
	
	int deleteUbByCode(Map<String,String> map);
	/**
	 * 查询网省名称以及平台名称
	 * @param corporationId
	 * @param orgNo
	 * @return
	 */
	List<Map<String,String>> selectBpCorporationName(Map<String,Object> map);
	
	int selectCorporationBoundCount(Map<String,String> map);
	int updateBoundStatus(Map<String, Object> mapParam);
	String selectLoginAccountById(String partnerId);
	
	int updateBoundStatusByID(Map<String, Object> updateParam);
	
	/**
	 * 根据partnerId,电费编号 查询绑定表
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	public List<Map<String,String>> selectMyCorporationBound(Map<String,Object> map);
	
	
	/**重新设置绑定状态
	 * @param map
	 * @return
	 */
	public int updateMyCorporationBound(Map<String,Object> map);
	
	
	
	
	/**將未綁定的設置狀態
	 * @param orderIds
	 * @return
	 */
	public int updateMyCorporationNoBound(Map<String,Object> map);
	
	
	
	/**
	 * 根据partnerId,户号，和主键，查询绑定表
	 * @param mapParam
	 * @return
	 * @throws Exception
	 */
	List<Map<String,Object>> selectBoundDetail(Map<String,Object> map);
	
	
	public int updateBoundInfo(Map<String,Object> map);
	
	int updateBonusPointsAndCorporationDvalue(Map<String, Object> map);
	/**
	 * 批量插入绑定表信息
	 * @param listBound
	 */
	void insertCorporationBoundPL(List<Map<String, Object>> listBound);
	void updateValueByCodePL(List<Map<String, Object>> jfList);
}
